SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420810 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420810 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376179,197639,575776,946688,913173,956,976067,557928,395525,643054,89828,104639,152108,85057,140710,42755,769758,914873,305499,68216,555519,25688,58123,271667,176841,115566,709897,528992,860449,865854,1023263,273221,460069,253660,257506,538873,648193,473834,967595,185371,52545,948324,425206,937219,866926,173713,783710,938315,911411,262778,857634,469934,748522,761098,290389,106191,854675,80430,712465,643481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]