SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542920 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542920 [ RunTime:0.002037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767883,709938,466058,943926,207696,697340,284032,587032,412933,804874,748042,529191,830074,996095,173712,917198,911351,386720,871808,342532,1040605,89682,738715,681311,492364,377641,994564,391071,805093,557264,948667,1042202,913795,481067,864425,626727,578037,318692,1048223,321681,689456,1044342,263102,249760,1030344,19009,686759,15352,974813,737160,370095,692504,26423,583040,5621,555313,155923,904891,798972,683233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]