SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405216 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405216 [ RunTime:0.003459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422125,224823,794806,511451,608831,355661,82454,594775,616532,502927,556751,137442,319167,393548,236757,224451,989330,26504,265824,377602,285199,378155,47032,78538,164583,292724,810580,913318,922406,595876,874421,956162,621764,342473,519298,370114,527633,636513,492635,10011,268478,402739,632333,378883,17605,742207,779344,123805,168839,222624,201100,558245,194957,371563,656133,775536,49016,512752,221261,807351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001922s ]