SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509913 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509913 [ RunTime:0.002522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411445,469636,690093,926483,250197,250778,991666,1023218,559132,453123,568282,459902,444582,395231,539303,490451,641298,393248,890311,91482,803322,483884,841694,411728,734088,487562,934341,526623,238168,771457,204618,375569,321743,375778,580442,206965,938991,480395,610223,194604,535649,564645,405299,9981,481561,891289,233225,317788,602988,47487,253198,902612,472513,408226,740048,265228,765030,1029949,160634,804537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]