SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557482 LIMIT 1 [ RunTime:0.000839s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557482 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819388,301279,910449,206196,317462,892219,200172,746515,292299,693344,12114,702102,337845,139233,394960,285477,281628,941744,683040,626092,74457,724244,48241,792300,566195,680243,352050,239747,391378,380402,181822,156278,345304,624478,653946,175628,261987,456642,126470,533950,365404,832531,735086,641094,105222,700042,225252,389031,945110,959227,235901,545789,416202,99826,661793,736951,253552,126757,680614,687016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002094s ]