SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450511 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450511 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238498,613129,833059,911639,432619,1026082,971952,471768,877771,356820,538044,634919,392978,970098,6460,605577,967904,1036630,325163,769164,672514,576316,934248,663410,421299,510022,64998,277240,323484,894010,611575,803070,317875,220466,476761,1018351,617572,428849,736653,151787,397754,664723,764340,811410,192445,689768,896079,74569,544400,1004344,134230,84314,674914,348458,416693,55628,1001960,155892,654904,850411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]