SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536907 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536907 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024824,873602,410648,268581,538631,600322,620222,814598,1016391,282824,686754,201665,821566,739964,947350,404461,751072,982360,806374,791556,851882,639724,828332,317263,667982,943669,505734,611788,543233,656229,163154,830510,95071,464521,501538,62277,922000,328412,712033,482371,430192,564364,415082,348,819756,763514,741238,111738,939361,746816,227285,235658,930771,565321,410922,511769,328355,244296,522178,80117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]