SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571111 LIMIT 1 [ RunTime:0.004366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571111 [ RunTime:0.005888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017640,574159,331788,167316,139811,1041914,588814,410301,300480,477991,176843,140296,237980,796631,869770,974300,929256,1043289,274550,203670,48439,131556,724958,576147,320810,968822,397517,1012292,367100,167150,44346,4895,1009880,972046,468991,1038717,283366,727063,523671,321140,560598,34368,232875,641744,465495,725908,1026350,568113,878366,330736,784651,657984,1030709,753569,368105,926684,281604,445567,88524,1011577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002018s ]