SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527968 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527968 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582179,679404,426370,953214,700094,496383,10835,1001940,154376,201190,379103,472294,646101,971587,392848,316278,353985,128172,442481,590843,165747,174562,988135,912165,283644,691189,496161,273553,465297,654036,20588,109327,96236,334685,158157,468912,863447,762377,220101,935803,23856,96328,1001127,674721,33596,36937,899196,573954,679328,1009280,759375,857979,437753,221548,978156,134334,756375,652718,712507,224586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001798s ]