SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204640 LIMIT 1 [ RunTime:0.000607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204640 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783210,814585,739978,1001613,172486,21899,66518,95113,646442,139979,682326,980584,267987,100380,289812,711112,10091,284597,750787,318094,194095,966688,291873,675823,826830,887352,838160,212643,681206,710244,635794,779069,926943,501041,645735,1006701,861367,750932,59852,431975,788588,327686,825477,851519,140816,759946,460648,346534,208732,567414,64270,197448,438793,1002101,605727,372074,215665,254390,705741,866389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]