SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402801 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402801 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264277,924719,741812,458211,492875,277399,410888,460238,789785,851748,285778,219469,1007052,938950,318450,382292,183080,869706,824966,176298,852493,756692,176140,607070,374490,464664,875368,187577,839067,860379,77031,240147,99343,430547,836693,855878,355458,808820,300150,351762,1034584,61241,958988,120930,496449,695642,798857,463364,547715,968427,490705,822469,166616,744830,772947,755729,306601,962441,702938,592700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]