SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022105 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022105 [ RunTime:0.002476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743850,338191,310046,1028723,886864,262296,38257,675279,950260,929240,197306,566270,164840,199994,720567,498048,950281,449471,921931,977848,209073,559080,977778,695344,242138,632963,777351,219370,798549,312248,41156,934002,648936,1043217,350479,713342,506357,576088,603241,230104,730108,66963,45421,590491,215270,811498,807566,559527,909647,126200,605613,242909,617498,16144,737732,481955,38046,124607,581688,820492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]