SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002106 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002106 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242291,221443,905169,538370,948886,921467,501786,58862,1028120,46665,966637,306493,396849,421395,776450,316815,477257,671963,210934,58245,337237,631463,778135,671581,713731,924801,1006424,203039,626214,658564,544541,140864,933070,942355,271411,549592,721826,578158,194728,193584,460976,873564,357303,184230,755998,787663,297648,257735,457259,314106,25417,890200,996949,305070,741614,917630,149200,508031,820750,625391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003867s ]