SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403992 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403992 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748918,65318,275941,590134,402818,684499,45070,774774,631485,62081,388822,954252,888693,118440,250583,677783,757956,918198,91507,1011098,178384,203599,24179,826381,178107,648492,731038,121481,278911,44838,5996,260229,551493,812656,115405,7100,720681,90471,183878,429698,920908,661730,776295,316243,1407,1012040,310717,177264,107662,149340,887477,197104,644700,521891,867892,655092,485399,892172,614936,862603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]