SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914808 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914808 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165590,742103,52013,193140,63374,844315,175765,470415,1026844,803907,996712,940111,837014,99631,894685,969620,25127,570484,885610,349004,276087,584011,4955,1006035,421100,201719,31838,782936,192781,188634,578510,383849,541483,375379,323291,451727,9939,191545,173000,323593,1034609,324493,134559,845905,370987,60637,761230,861161,185394,537990,1004734,84809,750458,452173,88475,851753,141235,833139,700392,570744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]