SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418185 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418185 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188077,900991,864681,182918,638630,352563,228935,561612,557643,406865,340576,160092,104056,89846,208507,167166,394327,224494,463140,849722,890678,865135,597884,205096,953527,720560,994208,973080,535727,686088,994304,529214,567472,296586,343442,209146,664805,195367,704584,121210,51960,74496,948495,698987,794011,907439,760103,403325,708286,1026319,805423,49223,664791,736673,687084,294645,716813,31687,933167,253304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]