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` = 681900 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681900 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453014,290732,420042,424519,658546,769684,637880,457082,278042,739905,841348,390471,174035,885350,521759,272910,979273,1028262,910413,584073,280575,689584,330934,655725,121144,645811,729951,1002518,321658,606043,361799,586087,261127,699452,803436,157740,771102,81483,298710,228223,304308,1032035,780829,895409,116526,42934,281934,262491,706373,246665,544859,844337,736313,630464,510084,908073,949982,820472,225773,554211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]