SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32218 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32218 [ RunTime:0.001386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273302,574068,845683,980557,156233,989317,986682,6491,1024735,393792,1037491,208352,296340,134332,476659,370362,136194,685508,982127,257823,678734,1039409,856973,208307,1040178,378281,32004,837083,665330,746060,363883,130810,179931,914641,427242,249658,508671,56072,582565,209464,563613,968630,772052,333097,811595,904480,489985,592865,424894,793681,601828,456245,745702,645565,826280,427001,520923,427339,855787,667324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001537s ]