SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313576 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313576 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172598,315029,316451,549302,166884,937792,87582,488677,954536,756068,1037320,624377,392606,943762,92153,331648,579428,502017,198655,523206,176968,227234,541511,374689,1016009,361969,278369,304617,883125,174673,928954,16391,481044,721410,558580,498363,118979,540742,178757,503974,358545,830968,228285,574450,93775,565270,1007812,690479,572658,796880,595002,938139,958706,919218,632892,484493,294167,820555,144640,257808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001232s ]