SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424513 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424513 [ RunTime:0.003058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53324,198491,268869,255014,507249,1015229,227039,714973,455110,356274,244991,661016,457706,617690,959002,475064,1015262,678682,966933,636960,1048331,582970,981868,499428,796647,656739,937947,973541,463425,111713,957739,851281,733824,324385,544886,732878,1048388,533253,379441,844530,942554,1033035,1008319,584079,665023,548413,371887,177235,348522,608166,560985,234838,248499,883698,639821,651173,703715,733005,981839,447985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]