SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201280 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201280 [ RunTime:0.002214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573406,605360,518586,13764,594818,1044401,46758,98659,512170,437195,51121,67120,202453,288715,705382,60583,592949,355491,325587,845204,120590,353868,121307,827451,399775,663952,60936,232562,133763,469304,504023,310259,997239,778783,77033,942558,894478,801534,806082,255771,182685,373365,245717,943716,642820,828755,775104,734747,30931,104444,554202,407582,921044,766734,447251,122077,322670,140332,691191,254210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]