SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991990 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991990 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428344,1044714,732905,138528,364529,588152,220923,253168,13769,849890,732578,1041228,950747,418091,457733,337170,426308,325233,708639,808433,718227,287103,457386,771029,75692,187614,785644,1033326,946550,722681,296262,575273,610857,423741,122413,847795,526977,571566,877618,381377,460588,51051,759500,346930,459915,243192,234069,821126,257080,249146,375208,383594,171776,527058,561298,729173,43547,631406,500233,734555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]