SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412740 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412740 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895593,48699,592664,284113,244820,705055,101440,676698,480701,249852,799790,1010488,364771,604514,482424,470414,83470,741679,434869,823316,257518,771058,806978,246436,855269,822242,167646,322735,30827,161686,301384,428044,580181,32807,426835,564570,954580,888667,848884,360489,779837,112405,339895,804082,355592,535054,578755,208110,423527,397749,380248,621472,383216,236998,457028,169254,979686,693591,138014,742180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]