SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448393 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448393 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17801,504072,987573,709699,662023,295242,77267,220906,690068,443845,791462,457749,517073,905777,217497,133529,810891,359553,1040632,1042345,256851,297867,530143,713011,217356,567306,574525,27689,658249,63515,341779,155254,12777,166120,513876,850557,351417,935662,158310,449353,977515,817123,1009584,212562,735502,1008693,163916,474264,802496,124151,672969,143178,679428,73859,30836,258832,134220,361596,563161,461923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]