SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170512 LIMIT 1 [ RunTime:0.000903s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170512 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658196,418391,850620,745258,709122,720249,106080,188261,412689,493534,726070,529915,367529,721959,445705,415178,785907,711651,207672,951511,962113,639457,444331,78037,194354,350618,670536,808707,345,479405,511768,897209,687481,374469,99252,865797,78831,965675,512346,111110,641211,266909,971990,38125,576599,210240,388382,451787,656255,309319,281083,386361,334194,322495,911926,725603,580853,939060,412590,503047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]