SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585912 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585912 [ RunTime:0.003510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139359,588191,328956,920942,937708,900684,531466,677458,340094,255013,314304,1034009,383593,812328,945378,247475,609623,1000324,630712,677523,226335,143558,600447,311614,519211,318434,100536,892698,563258,761553,547536,947840,662737,815880,559653,1037342,605535,446037,33942,2968,1041532,232937,663717,241602,418812,337325,89724,856503,569894,762313,418128,621324,866305,186877,749994,476844,480857,728317,525412,941769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]