SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312991 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312991 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415220,187837,1003237,218672,271704,948518,949786,945740,782616,845672,201979,483948,563528,1031057,645282,66849,476506,139995,289870,621929,1005764,890735,6375,299928,642363,379628,412490,658021,374276,612738,94214,840472,860483,289977,979114,859462,301613,237803,683540,915142,397816,368231,800797,1039834,936580,1018634,637797,515178,877648,463750,228556,219852,622520,501428,960973,987544,584244,422816,574740,745106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]