SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012662 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012662 [ RunTime:0.005691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715151,567374,196259,276638,479025,505444,158827,563276,674459,304447,468998,901562,995164,74508,648823,479683,802686,952710,345825,1019185,528896,980958,636911,327411,459747,337090,535409,700836,110100,801358,322926,702229,378868,1040779,108262,663307,945737,977132,909055,913910,821363,193492,71115,1010280,532747,779000,656282,370756,315028,605211,342969,444772,354522,866888,450792,710134,331315,1036234,945583,139247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003034s ]