SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020541 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020541 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774103,953456,864585,598386,389288,587636,399745,1033439,307199,922874,864803,948515,897776,20803,221444,272262,368511,295104,262865,332403,664476,111057,785940,782878,63154,719551,876694,441680,276137,266040,861899,62006,929780,377187,351206,340993,231156,457845,431311,570958,344138,1023257,426795,233775,31851,539453,85929,750271,152528,187242,281670,491678,774251,8423,107514,770367,550371,68401,318630,44727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]