SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326301 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326301 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186380,448753,148256,681247,451602,562757,617935,816906,377452,189869,677271,32321,180296,372806,604118,551232,288763,1045543,686639,626595,1028321,746454,194390,106691,856011,845435,607818,333911,369209,398184,991284,1002094,214884,1034750,1021399,1003411,1010402,430149,101216,556070,963178,275649,456610,935913,606410,851935,96951,466838,446624,612231,486949,545917,242908,857022,23339,518942,650045,33566,368423,86343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]