SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490546 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490546 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412829,52660,1021818,606768,756100,962722,714207,511204,11125,1046855,564483,255846,526302,667557,1045800,552413,273172,962413,770023,447787,793178,560744,989772,512439,681618,546552,151725,49120,922408,262180,535011,859621,384633,916342,539887,237342,971984,530514,74694,687106,561868,358563,900606,27537,8977,215253,585196,282330,974208,269964,336647,385240,425508,367888,300938,575301,635454,485133,997492,806426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]