SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146410 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146410 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191264,823280,400308,511254,1002606,238696,915796,657010,511563,413442,63156,58664,694379,446165,700897,605926,932686,28900,360828,419604,272396,477788,764758,252624,945682,490288,722642,24962,752146,1021495,244710,475980,82259,298794,785602,95138,451866,343505,100999,512818,137335,1015529,96680,549240,718408,622979,740923,967476,870676,468704,513288,364251,236976,716892,948873,627652,736689,537485,353104,220029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000936s ]