SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102811 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102811 [ RunTime:0.003162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607212,109976,123037,1045228,759695,372375,914493,840756,732233,1038610,468080,78871,819052,307994,8167,502013,13602,789088,977436,988105,971168,252602,241805,167485,862189,984606,425250,628841,427710,908762,645446,84147,240474,420365,987527,543320,529321,268884,806969,296420,710507,280918,340031,366840,620050,771488,815805,825193,402067,406972,298949,532878,71954,279794,82189,854059,546143,68847,655397,45706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]