SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545943 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545943 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400584,526864,153790,301822,994647,28503,935704,82138,58434,639590,314215,353880,415850,92380,827559,934726,545900,251926,622492,985996,887874,615877,672448,774444,32498,366730,907225,782767,177958,612064,337014,753686,540393,399494,545788,575788,561927,871125,362103,792531,721111,493587,324842,486406,486701,711103,43161,721165,670880,640166,296113,796059,258759,332973,221607,759948,199225,366313,1008734,512902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]