SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524106 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524106 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137989,516704,717469,817674,136665,246405,699721,802379,219105,338014,490245,359157,267152,143705,364603,203645,629668,906782,817317,620293,572118,1027328,853416,37369,104659,40053,197700,1030739,511227,341237,144624,262986,863521,315528,416476,207236,702576,673611,633462,523896,335865,812648,325387,4512,97049,744376,350395,1031948,290782,283302,43156,640784,572268,380127,874654,2639,751564,928632,368030,253637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001237s ]