SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520019 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520019 [ RunTime:0.002716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31426,1020907,671781,18849,263311,292283,791147,363031,264925,364492,911558,245072,237117,688668,750115,238046,110193,732020,1037467,365291,1024796,18034,343332,66035,583244,784877,420513,404417,1026793,169283,970582,723184,425805,905342,169030,422575,348771,265605,510292,117102,569554,437782,380446,52416,877484,66900,479113,473168,95078,88105,554240,995130,985780,613393,497133,261639,682005,812897,339267,3280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]