SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467946 LIMIT 1 [ RunTime:0.000637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467946 [ RunTime:0.003647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39489,733762,854820,604091,861656,100157,415259,90063,137388,23155,925015,299077,1029912,875699,1033872,86337,670709,335258,933458,123213,355181,474447,270618,243964,874443,671391,274039,368227,518699,310663,901733,388589,199252,103554,346188,769715,49259,649511,440958,674296,243992,115666,698840,850318,513791,104339,970788,115463,77497,501706,506849,831368,779498,580695,299833,251761,245410,385656,627166,925040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]