SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539473 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539473 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417644,179777,937473,706268,528760,1033654,589581,897326,285917,438281,96377,844621,304663,400286,772744,285803,36779,956741,324867,187307,199721,526753,344435,257936,958973,6224,613340,463167,299849,170649,251577,142178,197023,234643,857898,613865,138361,191597,569265,224054,724176,14907,339046,241685,58478,1030030,457805,443786,94702,300980,933098,677417,662278,600903,392375,128534,469585,792872,17329,161334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001794s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]