SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 90180 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 90180 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964468,824190,804944,1006509,146056,1017893,527652,301454,458726,752195,585509,967996,146665,571950,709369,262790,714872,400694,117655,47066,257210,409018,643669,499039,514001,225422,1012997,19334,187633,237546,569037,676271,642722,331293,184363,178848,797583,963251,922995,381432,1037323,858283,343677,967135,467012,453061,162176,152444,509066,803719,3239,43013,547985,826590,1048450,989678,229312,681807,567137,279351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 90180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 90180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]