SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022673 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022673 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791324,96836,25010,853117,868569,455078,537220,850326,686614,944453,372787,612156,867454,288835,243380,87344,264040,112030,380511,721006,420771,278015,457759,779055,167848,973483,484403,559744,130263,572324,594710,860497,48936,331596,407551,200681,537927,212159,162843,929843,730594,447437,943305,190890,220489,773236,970260,199830,487066,903257,916073,672770,200433,147963,692703,969492,315566,1043731,75521,830723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]