SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201291 LIMIT 1 [ RunTime:0.000810s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201291 [ RunTime:0.006954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695021,987499,658841,884175,983663,324029,958630,234855,266347,829742,64235,832354,711368,356895,688425,367335,658436,484169,892517,877747,437748,1004734,537045,1002329,248189,678878,897421,435048,185239,1005308,605651,169290,929201,937099,599541,237216,354452,656731,150665,957165,1010525,990507,264789,805566,295339,665588,918593,754900,231253,390475,721961,556695,39613,189068,917065,857435,990825,759059,462058,709176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]