SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016072 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016072 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465295,424780,766421,710857,964303,858975,150790,11433,428188,438337,45491,14376,164715,701656,3555,896128,425819,161450,956141,198056,481696,869962,894487,477134,1013879,432927,528341,972999,573303,344893,57996,975757,1026841,1044833,153093,333434,933937,800381,977671,273954,7091,995527,106054,837106,801169,483995,316216,495432,87866,84289,541285,523149,547750,102314,341730,239627,234781,664593,717010,438809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]