SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505113 LIMIT 1 [ RunTime:0.001553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505113 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928221,1026959,948217,895038,831231,891553,283613,223595,1023154,659627,719852,14464,54656,106668,1046417,325085,156954,1037270,1031674,13892,894357,242987,479122,884859,22434,596998,153753,993637,938121,896928,867703,812853,394575,854286,785044,775151,216845,548296,6077,327086,1026702,510951,628438,671323,879380,987137,394230,348987,381909,435016,864721,654687,907153,987660,921125,919632,922210,828882,571697,716925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003379s ]