SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174722 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174722 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002415,131977,738863,855201,189942,703387,273269,508329,490171,634969,716205,428138,904110,817616,227202,276199,119050,451485,772870,125222,34673,104933,1035671,278538,307425,745506,190251,85291,988226,465876,877385,662552,199611,537423,370759,406175,898446,839466,717153,210264,424367,406595,905697,349634,239390,1011089,446713,1016001,334469,558998,13016,36789,449207,633293,762837,756427,541309,460365,256413,120889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]