SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480100 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480100 [ RunTime:0.003255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490122,406884,610880,137314,724531,732643,530898,741559,884801,339509,564084,1012987,210826,950327,809505,229357,961568,1012656,268025,883141,433340,298817,297649,593676,138141,925388,200178,722248,606406,299394,781882,586297,420726,390888,501153,69935,454522,714140,741111,799722,177735,501331,355419,734762,274949,163503,328395,635470,700256,856494,484154,670227,448718,3380,363271,1019355,630880,367720,918243,832732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]