SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020514 LIMIT 1 [ RunTime:0.001737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020514 [ RunTime:0.009273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29043,667075,211410,75878,832171,467382,398458,535395,535830,1031775,320411,43715,347411,206067,339334,284759,627366,621018,675492,77301,1030745,160148,887102,64604,1041538,558218,797691,838766,555144,793083,148948,558641,715882,118843,343090,724480,557789,616081,273346,91055,473060,924515,396487,823209,431121,30168,128014,333953,273817,866962,321933,142110,467117,19503,269353,40807,790737,974466,574498,289816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001177s ]