SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432489 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432489 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167763,321709,226217,215835,305482,793637,937869,649487,1754,1014225,425355,455730,233684,126196,285898,107957,174809,73264,258134,139254,577240,192615,931394,10136,295744,356274,804103,920344,844030,734012,954576,166023,344034,695949,919431,663794,489497,690587,1009367,89996,125588,88992,804303,848026,302937,444387,176798,881048,1041026,701259,328105,158014,600887,893244,227287,949474,372120,555014,971087,189309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000852s ]