SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040487 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040487 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927805,237981,379330,778452,925836,252624,352250,573171,833676,755216,634676,756730,193451,667694,688159,799986,892935,369450,541672,678071,1023969,241486,530487,379673,481448,461474,152487,528021,516831,1004263,281676,62037,694490,192223,280397,942937,794302,427964,357157,306795,250331,726956,926158,221112,735606,475859,536895,380631,132698,888113,594952,874713,976378,962897,59984,1000669,151401,585317,393415,491544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]