SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510211 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510211 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002964,888670,900687,813529,668886,963196,231449,840094,110735,878766,745141,71927,758627,629409,145218,392270,351834,330368,634662,750235,261366,971442,79,608797,327781,496048,776037,89365,192201,27440,228943,881245,60758,327934,222206,759277,976076,767526,134380,790141,95224,1008701,360244,732798,708741,985551,40321,558036,212068,212311,215240,1008463,376652,845699,240517,609926,90470,956143,923161,284962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]