SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523404 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523404 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751892,573107,280205,128543,943928,318275,707829,438662,28719,893278,848713,731407,429301,114814,198319,985701,210312,574460,197796,646385,965395,226024,946061,38275,246111,37055,536193,325004,710083,664761,587547,698341,102319,4257,337578,323468,652468,837541,820760,569829,127057,454212,379011,57482,691919,672280,248061,377309,104476,922890,723287,195765,462559,145336,388488,584827,982021,211016,234105,874617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]