SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045950 LIMIT 1 [ RunTime:0.000894s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045950 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419101,304637,584928,279811,800606,440715,561121,329448,828609,632000,812872,47178,208583,557445,543246,70183,134951,866053,151070,558777,627882,473265,980800,575653,196229,464530,964250,334287,557956,188102,723453,500627,749007,785409,898677,640278,362152,781843,1036204,784496,35455,388050,102252,769688,984836,703871,861066,101199,379059,620962,339880,265600,383957,464620,892482,395523,855659,478619,812500,642443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]