SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534085 LIMIT 1 [ RunTime:0.001425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534085 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031067,445352,994612,1007954,438125,879180,867119,122665,537334,906064,55060,615738,1007055,991304,409692,916186,604300,126232,219268,317799,560303,17612,579255,858839,682234,585692,43611,281113,12785,19086,857422,418426,210090,646433,381633,51546,653728,625316,539642,859076,746676,81447,65153,7616,620481,70228,510899,30652,107725,103489,519594,158661,310683,905865,40732,386388,16495,762264,978606,636582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]