SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383010 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383010 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470790,52082,357647,757640,414274,98560,571873,173848,233790,48917,441167,1015164,260010,9230,443824,626188,334491,216354,241454,663472,910865,490534,845279,60064,963989,303968,712637,583742,840325,658582,631285,16024,454668,970885,96040,834768,562520,551098,609193,310685,631019,702278,28453,79633,402256,888083,260195,567073,247196,363474,843626,648802,412287,704270,827477,986808,771925,801870,108045,355475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]