SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284946 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284946 [ RunTime:0.006087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511541,330351,378621,699442,585439,257501,23816,528948,738168,1038428,994727,119311,958445,683392,815166,992009,62879,1017420,300584,521518,653218,34773,790957,172477,191856,900471,200549,87984,281030,840466,289393,262261,607332,912353,638619,99010,225444,931931,533357,575545,1001590,763574,946371,420278,129053,231478,685770,641940,244924,225758,601331,223357,359086,501036,249576,1040029,652527,259520,382583,836393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]