SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564840 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564840 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953097,943773,996129,696220,319400,447261,74230,519024,624758,265327,358497,216293,92860,865037,227317,646812,314552,459441,503177,174755,700022,361734,719225,63345,674225,365988,545601,576021,900825,523093,1017768,910698,186082,407090,791986,53642,867230,23790,601852,584316,1019422,329820,76847,284464,37050,894852,548317,700111,374845,695680,37255,257316,551346,435786,856402,788120,772371,447507,972612,231689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]