SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466012 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466012 [ RunTime:0.002627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200526,497572,404437,141046,1040407,719301,244609,622494,358684,432395,335618,13332,850502,793223,891007,982431,409807,645167,593332,205422,593685,1037082,261399,190245,421178,338895,398373,631555,164383,402349,184458,388455,741308,693818,503886,500532,546861,515994,506697,408989,416880,440213,342727,727745,222958,29713,617429,698226,233611,249266,16444,84474,11156,962089,171762,326089,580810,412174,1033141,928080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]