SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282617 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282617 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771214,462944,835546,967121,131449,703596,855127,979012,41449,983484,389975,355578,219133,349278,556075,312226,721920,507525,700129,1001721,1031711,53794,293192,486138,490134,233500,621369,577181,566387,362231,741112,646845,583600,977243,844756,714990,177553,447673,416935,200634,421449,83128,781605,765666,650890,178657,4474,341258,262335,55362,832753,756267,584372,976580,902644,306017,527265,801920,880230,347194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]