SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016606 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016606 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234461,133384,500119,557567,259781,639692,1042532,424901,824695,327602,7475,1031311,453131,963217,709573,620285,777224,592997,590646,862783,853817,484286,671940,795184,480095,619929,907506,72575,288459,789640,945887,692812,632765,940200,1011192,1020349,385070,963957,311788,121867,303117,800970,202479,698090,483811,683867,397152,884341,843206,228951,548555,400304,361628,416665,272051,521153,245034,415180,801760,69140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]