SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401791 LIMIT 1 [ RunTime:0.001462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401791 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022440,766266,1008110,638789,285578,582870,116840,313619,473195,884799,335233,265406,521094,163888,930930,677917,192296,949339,336125,1008260,895278,848088,445708,31804,462582,87097,1017062,819903,672500,936519,222522,497758,132270,406769,114715,178291,387895,803852,480976,812465,254490,117639,19409,281569,540655,418228,220829,1026524,709436,679903,939537,1004229,13781,422195,725350,743397,241951,639260,19734,242117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]