SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512815 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512815 [ RunTime:0.002820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548916,555208,473096,361096,708784,203802,809961,353946,39367,41440,587474,398009,544588,816510,605308,306571,767623,508880,883887,122658,404103,200239,658246,850040,813239,248252,245571,639732,345758,729487,691347,350655,359725,114509,538383,655651,291730,188989,485689,1010494,907208,670493,509448,627505,177544,1030235,358022,980213,81427,679958,321794,479516,327679,977591,746526,346059,513266,456879,791828,404691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]