SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415844 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415844 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961674,981435,104155,903222,606917,685450,862544,665662,577614,725152,852183,973108,182837,337135,398355,471883,517280,767394,575336,147295,224,859487,249915,455168,719987,238542,1043541,335139,551202,217076,751985,929188,546866,968250,666079,626718,156828,899270,989964,544282,72338,961360,663156,226236,861007,864811,858918,996737,883072,1031585,608681,600984,144671,405356,154173,85339,777961,475219,32969,177431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]