SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105060 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105060 [ RunTime:0.002579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009219,243608,982811,465334,84480,254903,68566,68651,790325,27442,150348,65601,842525,600534,258317,401128,348760,233071,745260,773298,777793,459659,265921,595989,338603,326728,1048921,434788,545534,343897,297991,498440,760752,792246,148859,948971,725108,943926,492994,832721,172067,233724,996639,80673,879278,986564,513523,794744,996013,593629,616737,737047,108417,318304,756970,348329,950580,450636,895647,625452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]