SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519089 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519089 [ RunTime:0.002312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293636,834883,60201,1001165,702491,397968,618673,1015219,935534,315561,394200,745536,413680,900692,334632,271141,551129,251559,448183,192953,18701,1031262,693710,439957,805055,913041,273320,906338,539044,177880,593746,1046211,564909,186335,567707,206372,290519,548357,213954,13394,587407,471908,871625,132473,99593,792951,95401,157438,875742,161554,477793,588335,152726,483328,650321,273749,646576,231372,246833,822176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]