SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002839s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 183908 LIMIT 1 [ RunTime:0.001002s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 183908 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414886,871076,1024862,933609,149424,739116,817890,453152,435691,150746,430555,491905,365695,813247,703102,199617,606887,412527,472200,370246,90285,348096,425947,219998,1036057,804764,901483,308352,572007,748377,672958,64999,953525,650574,1027375,101377,196081,450814,15486,685998,817814,767411,370749,687979,448990,948569,373006,37156,45440,579654,759385,200130,142540,28708,1014086,549399,729516,685052,455233,770723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 183908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 183908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]