SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104417 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104417 [ RunTime:0.001421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649377,449359,929902,456213,559253,29108,928303,25383,658961,127331,755008,377126,207926,64248,686891,995759,271517,227547,715157,735892,982726,702275,768182,1040710,1037928,468771,979617,469177,154519,379332,82308,1001334,581931,653917,937820,958067,414002,194996,396590,965096,475763,749083,387734,156969,689740,520504,771638,245448,733496,680778,658619,644988,406965,375191,598044,380666,1025820,187329,226517,720566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]