SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433208 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433208 [ RunTime:0.002584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7020,572604,932376,433588,542217,1006041,459965,750239,1016117,865218,74067,252533,1029019,375582,869430,579429,133507,830841,704021,732269,164675,56298,466460,999631,739207,238607,627120,559276,274929,140822,516219,917803,258496,101632,883454,581871,504027,69127,926566,37248,1006902,551350,380142,979894,564674,593925,773211,388710,883603,819207,484244,277266,83531,920445,258729,780629,111550,579902,207153,488291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]