SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503588 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503588 [ RunTime:0.002905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158046,654127,296166,876649,353751,561408,1023938,136370,88865,158474,752481,413586,741574,882002,879453,1017399,58909,707527,507975,324503,74270,952939,370669,173158,265501,818840,34964,989511,90225,619775,775990,908797,1045022,53931,846051,1045143,598870,754805,295362,445068,617242,502280,752918,834569,747828,870919,611651,538738,707578,611695,737550,571234,380654,411577,543027,322832,625638,709483,921746,27703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000870s ]