SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019113 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019113 [ RunTime:0.004142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664231,906939,189663,739156,1035010,69033,38222,521790,180221,998170,617694,343872,222390,102616,354920,465911,665902,445086,229022,120669,562133,1047867,101001,713804,546311,219918,225288,638411,484589,488689,419686,662139,761520,1007797,676615,891630,599717,916907,404597,865201,568926,599200,1030657,862568,923244,398790,52747,710952,695564,580018,560178,250872,432816,250063,211178,99951,124329,176692,1015876,140885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]