SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 652004 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 652004 [ RunTime:0.004905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524149,905820,859550,893755,572899,842059,164564,76511,182402,914939,643020,477103,442415,826510,314356,1029625,206362,278243,752314,290633,603850,74904,208988,266450,1034382,1040284,502818,664379,506288,47889,775172,527203,947205,929274,515702,628943,148992,672282,736427,732663,843040,250974,488468,219141,780638,648976,853017,423484,207655,292551,571755,16085,361393,967913,791165,917076,1008725,152936,113365,52212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 652004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 652004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]